-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 16, 2012 at 12:46 AM
-- Server version: 5.1.36
-- PHP Version: 5.2.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `muathenhanh`
--

-- --------------------------------------------------------

--
-- Table structure for table `dichvu`
--

CREATE TABLE IF NOT EXISTS `dichvu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seq` int(11) NOT NULL,
  `iddm` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `noidung` text,
  `luotxem` int(11) NOT NULL DEFAULT '0',
  `insert_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `dichvu`
--

INSERT INTO `dichvu` (`id`, `seq`, `iddm`, `name`, `noidung`, `luotxem`, `insert_at`, `update_at`) VALUES
(3, 3, 0, 'LIVING ROOM', '<p>LIVING ROOM</p>\r\n<p>&nbsp;</p>', 0, '2012-05-15 23:42:10', '2012-05-15 22:42:10'),
(4, 5, 0, 'DINING ROOMS', '<p>DINING ROOMS</p>', 0, '2012-05-15 23:47:25', '2012-05-15 22:47:25'),
(5, 2, 0, 'BEDROOM', '<p>BEDROOM</p>', 0, '2012-05-15 23:47:40', '2012-05-15 22:47:40'),
(6, 4, 0, 'KITCHEN CABINETS', '<p>KITCHEN CABINETS</p>', 0, '2012-05-15 23:47:57', '2012-05-15 22:47:57'),
(7, 6, 0, 'WARDROBES', '<p>WARDROBES</p>', 0, '2012-05-15 23:48:19', '2012-05-15 22:48:19');

-- --------------------------------------------------------

--
-- Table structure for table `giohang`
--

CREATE TABLE IF NOT EXISTS `giohang` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gh_user` int(11) NOT NULL,
  `gh_sanpham` int(11) NOT NULL,
  `soluong` int(11) NOT NULL DEFAULT '0',
  `dongia` int(11) NOT NULL DEFAULT '0',
  `tongtien` int(11) NOT NULL DEFAULT '0',
  `active` int(11) NOT NULL DEFAULT '0',
  `tensanpham` varchar(150) NOT NULL,
  `del` int(11) NOT NULL DEFAULT '0',
  `insert_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `giohang`
--

INSERT INTO `giohang` (`id`, `gh_user`, `gh_sanpham`, `soluong`, `dongia`, `tongtien`, `active`, `tensanpham`, `del`, `insert_at`, `update_at`) VALUES
(1, 1, 2, 2, 95, 190, 0, 'Má»‡nh giÃ¡ 100', 0, '2012-05-13 20:51:29', '2012-05-13 19:51:29'),
(2, 1, 1, 10, 50, 500, 0, 'Menh gia 50', 0, '2012-05-13 20:53:28', '2012-05-13 19:53:28');

-- --------------------------------------------------------

--
-- Table structure for table `m_news`
--

CREATE TABLE IF NOT EXISTS `m_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idc` int(11) DEFAULT NULL,
  `seq` int(11) NOT NULL,
  `tieude` varchar(255) DEFAULT NULL,
  `tomtat` text,
  `noidung` text,
  `luotxem` int(11) NOT NULL DEFAULT '0',
  `code` varchar(100) DEFAULT NULL,
  `insert_at` date DEFAULT '0000-00-00',
  `update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `m_news`
--

INSERT INTO `m_news` (`id`, `idc`, `seq`, `tieude`, `tomtat`, `noidung`, `luotxem`, `code`, `insert_at`, `update_at`) VALUES
(1, 1, 1, 'Viettel khuyen mai lon', 'Viettel khuyáº¿n mÃ£i 50% giÃ¡ trá»‹ thuÃª bao tá»« ngÃ y...', '<p>Viettel khuyen mai lon</p>', 0, NULL, '2012-05-14', '2012-05-14 22:07:23'),
(2, 1, 2, 'Viettel khuyen mai khung', 'Viettel khuyáº¿n mÃ£i 50% giÃ¡ trá»‹ thuÃª bao tá»« ngÃ y...', '<p>Viettel khuyáº¿n m&atilde;i 50% gi&aacute; trá»‹ thu&ecirc; bao tá»« ng&agrave;y...</p>', 0, NULL, '2012-05-14', '2012-05-14 22:07:50'),
(3, 2, 3, 'My danh iran', 'My danh iran', 'My danh iran', 0, NULL, '2012-05-14', '2012-05-14 22:08:12'),
(4, 1, 4, 'Mobile khuyen mai', 'Mobile khuyen mai 50%', '', 0, NULL, '2012-05-15', '2012-05-15 01:02:36'),
(5, 1, 5, 'Vinaphone khuyen mai', 'Vinaphone khuyen mai 100%', '', 0, NULL, '2012-05-15', '2012-05-15 01:03:04');

-- --------------------------------------------------------

--
-- Table structure for table `m_user`
--

CREATE TABLE IF NOT EXISTS `m_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seq` int(11) NOT NULL DEFAULT '0',
  `code` varchar(100) DEFAULT NULL,
  `nickname` varchar(50) NOT NULL,
  `pass` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(12) DEFAULT NULL,
  `hoten` varchar(50) DEFAULT NULL,
  `gioitinh` int(11) DEFAULT NULL,
  `ngaysinh` datetime DEFAULT NULL,
  `quyen` int(11) NOT NULL DEFAULT '0',
  `diachi` varchar(150) DEFAULT NULL,
  `money` int(11) NOT NULL DEFAULT '0',
  `del` int(11) NOT NULL DEFAULT '0',
  `insert_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `m_user`
--

INSERT INTO `m_user` (`id`, `seq`, `code`, `nickname`, `pass`, `email`, `phone`, `hoten`, `gioitinh`, `ngaysinh`, `quyen`, `diachi`, `money`, `del`, `insert_at`, `update_at`) VALUES
(1, 1, NULL, 'admin', '202cb962ac59075b964b07152d234b70', 'pvtam28@gmail.com', NULL, 'Phung Van Tam', NULL, NULL, 0, NULL, 500000, 0, '0000-00-00 00:00:00', '2012-04-21 16:36:50'),
(2, 2, NULL, 'xuantamvn08', '202cb962ac59075b964b07152d234b70', 'tam.runsystem@gmail.com', NULL, NULL, NULL, NULL, 0, NULL, 0, 0, '0000-00-00 00:00:00', '2012-04-21 16:46:07');

-- --------------------------------------------------------

--
-- Table structure for table `sanpham`
--

CREATE TABLE IF NOT EXISTS `sanpham` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `iddm` int(11) NOT NULL DEFAULT '0',
  `iddmc` int(11) DEFAULT NULL,
  `seq` int(11) NOT NULL DEFAULT '0',
  `code` varchar(100) DEFAULT NULL,
  `name` varchar(150) DEFAULT NULL,
  `gia1` varchar(20) NOT NULL DEFAULT '0',
  `gia2` varchar(20) NOT NULL DEFAULT '0',
  `soluong` int(11) NOT NULL DEFAULT '0',
  `check_new` int(11) NOT NULL DEFAULT '0',
  `check_km` int(11) NOT NULL DEFAULT '0',
  `check_dis` int(11) NOT NULL DEFAULT '0',
  `mota` text,
  `insert_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `sanpham`
--

INSERT INTO `sanpham` (`id`, `iddm`, `iddmc`, `seq`, `code`, `name`, `gia1`, `gia2`, `soluong`, `check_new`, `check_km`, `check_dis`, `mota`, `insert_at`, `update_at`) VALUES
(1, 9, 5, 0, '12052012-220151-fpt.jpg', 'Menh gia 50', '50', '48', 10, 1, 0, 1, 'the rat hay', '2012-04-24 00:00:00', '2012-04-24 22:45:49'),
(2, 9, 5, 1, '', 'Má»‡nh giÃ¡ 100', '100', '95', 19, 0, 1, 1, '', '2012-05-12 23:15:27', '2012-05-12 22:15:27'),
(3, 12, 0, 2, '', 'Má»‡nh giÃ¡ 100', '90', '50', 4, 0, 1, 1, '', '2012-05-13 00:14:05', '2012-05-12 23:14:05');

-- --------------------------------------------------------

--
-- Table structure for table `sp_category`
--

CREATE TABLE IF NOT EXISTS `sp_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seq` int(11) NOT NULL DEFAULT '0',
  `code` varchar(100) DEFAULT NULL,
  `name` varchar(150) DEFAULT NULL,
  `insert_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `sp_category`
--

INSERT INTO `sp_category` (`id`, `seq`, `code`, `name`, `insert_at`, `update_at`) VALUES
(9, 6, '20120426-004211-viettel.jpg', 'Tháº» Ä‘iá»‡n thoáº¡i di Ä‘á»™ng', '2012-04-26 00:40:56', '2012-04-25 23:40:56'),
(10, 2, '20120426-004327-fpt.jpg', 'Tháº» Ä‘iá»‡n thoáº¡i Internet', '2012-04-26 00:43:29', '2012-04-25 23:43:29'),
(11, 3, '20120426-004435-worldfone.jpg', 'Tháº» Ä‘iá»‡n thoáº¡i Viop', '2012-04-26 00:44:37', '2012-04-25 23:44:37'),
(12, 4, '20120426-004511-vinagame.jpg', 'Tháº» game online', '2012-04-26 00:45:15', '2012-04-25 23:45:15'),
(13, 5, '20120426-004614-snetfone.jpg', 'Pháº§n má»m báº£n quyá»n', '2012-04-26 00:46:16', '2012-04-25 23:46:16'),
(14, 1, '20120426-004659-mox.jpg', 'Dá»‹ch vá»¥ lÆ°u trá»¯', '2012-04-26 00:47:01', '2012-04-25 23:47:01');

-- --------------------------------------------------------

--
-- Table structure for table `sp_sub_category`
--

CREATE TABLE IF NOT EXISTS `sp_sub_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `iddm` int(11) NOT NULL,
  `seq` int(11) NOT NULL DEFAULT '0',
  `code` varchar(100) DEFAULT NULL,
  `name` varchar(150) DEFAULT NULL,
  `insert_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `sp_sub_category`
--

INSERT INTO `sp_sub_category` (`id`, `iddm`, `seq`, `code`, `name`, `insert_at`, `update_at`) VALUES
(2, 9, 3, '20120428-011204-mobifone.jpg', 'Tháº» Mobifone', '2012-04-28 01:11:11', '2012-04-28 00:11:11'),
(3, 9, 2, '20120428-011313-beeline.jpg', 'Tháº» Beeline', '2012-04-28 01:13:16', '2012-04-28 00:13:16'),
(5, 9, 4, '20120428-012003-viettel.jpg', 'Tháº» Viettel', '2012-04-28 01:20:05', '2012-04-28 00:20:05');
